package org.niit.dao

import org.niit.util.JDBCUtil

import java.sql.Connection

/**
 * Date:2025/6/5
 * Author：Ys
 * Description:
 */
class AreaAdDao {

  def insertAreaCityAdCount(day:String,area:String,city:String,adid:String,count:Int): Unit = {

    val conn: Connection = JDBCUtil.getConnection

    JDBCUtil.executeUpdate(conn,"insert into area_city_ad_count(dt,area,city,adid,count) " +
      "values (?,?,?,?,?) on duplicate key update count = count +?",Array(day,area,city,adid,count,count)
    )

    conn.close()
  }

}
